<!doctype html>
<html lang="en">
 <head>
 <meta charset="UTF-8">  
  <title>视频列表</title>
 </head>
 <body>
 <?php
 
  require_once('inc_admin.php');
   require_once('menu.php');
  connect();
  //编写sql语句
  $sql = 'select vid, videoname, tid, pic, intro, uploaddate, uploadadmin, hittimes,downtimes,address from videos';
  //echo $sql.'<br/>';  
  $result = fetch_array($sql); 
 ?>
 <center><h3>视频列表</h3></center>
 <table align="center" width="80%" border=1> 
 <tr>
   <th>编号</th>
   <th>视频名称</th>   
   <th>类型</th>
   <th width='80'>图片</th>
   <th>简介</th>
   <th>上传时间</th>
   <th>上传者</th> 
   <th>点击次数</th> 
   <th>下载次数</th> 
   <th>下载地址</th> 
   <th>操作</th>
 </tr>
 <?php
  foreach ($result as $row) {
	 echo '<tr>';
	 echo '<td>'.$row['vid'].'</td>';
	 echo '<td>'.$row['videoname'].'</td>';	 
	 echo '<td>'.$row['tid'].'</td>';
   echo '<td align="center"><img src='.$row['pic'].' width=60 height=80></td>';  
	 echo '<td>'.$row['intro'].'</td>';
	 echo '<td>'.$row['uploaddate'].'</td>';   
	 echo '<td>'.$row['uploadadmin'].'</td>';	 
   echo '<td>'.$row['hittimes'].'</td>';  
   echo '<td>'.$row['downtimes'].'</td>';  
   echo '<td>'.$row['address'].'</td>';  	  
	 echo '<td><td><a href="videoadd2.html">添加</a> <a href="videoeditform.php?id='.$row['vid'].' ">修改</a> | 
	 <a href="videodelete.php?id='.$row['vid'].'" onClick="return confirm(\'确定要删除吗？\');">删除</a></td>';
	 echo '</tr>';  
  }
  echo '</table>';  
  $totalrows = count($result);
  echo "<table align='center'><tr><td>共有{$totalrows}个视频</td></tr></table>";   
 ?>
 </body>
</html>